select NAME, rank, count, surname_entries.id 'wiki_id' from surnames left join surname_entries on surname_entries.surname = surnames.name and surname_entries.entry_type = 1 where index2 = 'SW' order by rank asc limit 0,100 Surnames > S > SW > SWY

Surnames > S > SW > SWY

A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
SA SB SC SD SE SF SG SH SI SJ SK SL SM SN SO SP SQ SR ST SU SV SW SY SZ
SWA SWE SWI SWO SWY

Full Surname List Starting with SWY(Alphabetical)

SWYDEN
SWYERS
SWYGART
SWYGERT
SWYMER
SWYTER

Top 100 Surnames in the 2010 US Census starting with SWY

SurnameCountRankWiki?
SWYERS 814 29117 no
SWYGERT 635 35447 no
SWYGART 224 83834 no
SWYMER 108 151532 no
SWYDEN 104 156044 no
SWYTER 103 157234 no